package basic.bao;

import java.util.List;

import basic.a6.Countries;
import basic.a6.Employees;

public class Test {

	public static void main(String[] args) {
//		DepartmentDao d = new DepartmentDao();
//		List<Departments> li = d.findAll();
//		for (Departments i : li) {
//			System.out.println(i.toString());
//		}
//
//		Countries co = new Countries();
//		CountryDao c = new CountryDao();
//		co.setCountry_id("DD");
//		co.setCountry_name("nn");
//		co.setRegion_id(3);
//		c.insert(co);
//		
//		
//		CountryDao cc = new CountryDao();
//		Countries cr = new Countries();
//		cr.setCountry_id("'DD'");
//		cc.delete(cr);
//		
//		Countries cs=new Countries();
//		CountryDao css=new CountryDao();
//		cs.setCountry_name("'Canada'");
//		css.update(cs, "'1111'");
//		cs.setCountry_id("''");
//		css.update(cs, "'Ba'");
//		System.out.println("更新成功");
		
//		CountryDao dd=new CountryDao();
//		Countries coun=dd.findone("AU");
//		System.out.println(coun.toString());
		
//		CountryDao da=new CountryDao();
//		List<Countries> lit=da.findByCountryName("A%");
//		for (Countries c: lit) {
//			System.out.println(c.getCountry_name());
//		}
		Employeedao em=new Employeedao();
		List<Employees> liss=em.findAvg();
		for (Employees e: liss) {
			System.out.println(e.toString());
		}
	}

}
